Hello I am getting the follwoing error message when I run the report. This report is going to get the data from DB2 database and I am not able to get the report. Please let me know if any one have any idea on this. Thanks! An error has occurred during report processing. Cannot create a connection to data source 'DataSource1'. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Hi, Please check the data source connection type and connection string. This can be done with the following instructions. Open the report using Report Manager. Go to Properties tab and select Data Sources in the left panel. If the report uses a custom data source, check the connection type and connection string. If the report uses a shared data source, you can open the data source according the location on the report server. Then check the connection type and connection string on Properties tab. If there are any more questions, please let me know.Thanks.

Thanks for your reply. After I recycled the services it is working fine. Thanks!

How you did recycled the services? can you please tell me how you did. I am in same boat. Here is the my issue. I am getting the follwoing error message when I run the report. This report is going to get the data from sysbase database and I am not able to get the report. An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'DataSource2'. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Thanks in advance for your help.

atchaiah - did you get the problem resolved? if yes, pls provide the solution

We are having the same issue of the report not running but we already have the ODBC connection established while designing the report. When we press the "RUN" button in Microsoft Report Builder we get the error of not being connected through the ODBC connection anymore. We are using a connection to AS400 via ODBC and can't get the report to run when pressing the button to run it even though we can see the tables and model the report with a good connection. Pressing the "RUN" button triggers the failure.